UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3iPG3ykuL2ra8KrR+td4aYfZ0DdOwW/LhXDeZK5Jkz4='
WHERE
key_id = 'f2d824dfe12aa9da7a8a46dccb9621f487e00316901fd8a847b23067d6b8c1d1'
AND (
token = '3iPG3ykuL2ra8KrR+td4aYfZ0DdOwW/LhXDeZK5Jkz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)