UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'asTMMmEfPjK1q/A5+TjLWFiBBIgXAGGLgcx2Ttq6Eg8='
WHERE
key_id = '0d47e7f8258e583c05a72537e2ba665cc73ab69093644346a5f78b8b73e03af7'
AND (
token = 'asTMMmEfPjK1q/A5+TjLWFiBBIgXAGGLgcx2Ttq6Eg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)