UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IrIz2gcCsbvVHk4T5IusQ6xE1hCuChOFULQwaDM9uHk='
WHERE
key_id = '712d2273d63e38a346f0f0a1ce15bd98bec49ced833f6562324bc71331977470'
AND (
token = 'IrIz2gcCsbvVHk4T5IusQ6xE1hCuChOFULQwaDM9uHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)