UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KMgYugfQM+CM9GQT6VRA9dgKI9NEnaZ3S3TLQIFV4Hw='
WHERE
key_id = 'b1238bb796437a763bf6d032425de1bfc6e9506aa20be431adc81a180990d3ce'
AND (
token = 'KMgYugfQM+CM9GQT6VRA9dgKI9NEnaZ3S3TLQIFV4Hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)