UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFvTAkW353VFjmtnTcpGANJ2Y4ZluIApHWpIXCe4e68='
WHERE
key_id = '28f2ad8b72eb069a68dcdbff9c0ac794be7fecec9b3bdf337acbab3ff4b3d130'
AND (
token = 'XFvTAkW353VFjmtnTcpGANJ2Y4ZluIApHWpIXCe4e68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)