UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fV4YUcof1lKts5dG5Kd1AOuiqHvrk5EJq5f/P9gGIYw='
WHERE
key_id = '5d2782c59423b7c4083706cb3927270e6f808ca9334349ac6f509b70da7cda5a'
AND (
token = 'fV4YUcof1lKts5dG5Kd1AOuiqHvrk5EJq5f/P9gGIYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)