UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/X3DXUvEymhyYmBQJGQWPt4fpFx/nu5vAguqTiTi/Iw='
WHERE
key_id = '4c5aaf7f63694025a304df03d0ab70c38e75938f520a890a1a857411db41208e'
AND (
token = '/X3DXUvEymhyYmBQJGQWPt4fpFx/nu5vAguqTiTi/Iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)