UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+zVKHPxfONDHjNCRZqZJzzYSbZ0lr4BM0+T4Z6cw+do='
WHERE
key_id = '5a31ca24bb72e29264ad265df2768bb4ce7706051675573c8a3bc03d4ad7d8e8'
AND (
token = '+zVKHPxfONDHjNCRZqZJzzYSbZ0lr4BM0+T4Z6cw+do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)