UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5hGEDpgvFkOPflwcZ6FC+qsQs+wCTKRi8C1GEkRQ+gw='
WHERE
key_id = '2c1a332722150413b0c1ee46ba8868d1f2bee5971903263ae834571c722cc9d6'
AND (
token = '5hGEDpgvFkOPflwcZ6FC+qsQs+wCTKRi8C1GEkRQ+gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)