UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mJ5DOaBRhbmD6LtBCslokI7KRTuGYu1UdU12HUrPmlw='
WHERE
key_id = '18dbd9ecda766908584263d6d617839edaceaa83675e5cf1fc58376ebdd86d4f'
AND (
token = 'mJ5DOaBRhbmD6LtBCslokI7KRTuGYu1UdU12HUrPmlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)