UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DaCWVmBLy1MpCn5OgPDhmasnOA5LZ3ImHw6ZJKhAeQI='
WHERE
key_id = 'bc03c6e6d70d3ba3346f2ac57eda7ab7b2ad5806866af258f7f3e15494a395b9'
AND (
token = 'DaCWVmBLy1MpCn5OgPDhmasnOA5LZ3ImHw6ZJKhAeQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)