UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h/mMBz7hfJd0wzc9JNhGNTapCTp7gaGOCfdyU2yX0ac='
WHERE
key_id = 'a8846a9cb9211f68d27df8f1b48f7b9c9ee22835e1495939ec891f83d02b863c'
AND (
token = 'h/mMBz7hfJd0wzc9JNhGNTapCTp7gaGOCfdyU2yX0ac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)