UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l010WM1r3g8bLAbV21uLHqf60cRRvL1RaSwA1oHDIEQ='
WHERE
key_id = '2a7d5fb27358a93013ac80c54ede0837a3ecd58c6ca7697891d89a6b08198589'
AND (
token = 'l010WM1r3g8bLAbV21uLHqf60cRRvL1RaSwA1oHDIEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)