UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CpLH+gd/+KYVbAvTu0gp5DKbBoUlPLug6yDcDilxQLs='
WHERE
key_id = '1e77d566598e752990ff76883722b9ce08333cc5cdef340ddcc8de4c6c70a694'
AND (
token = 'CpLH+gd/+KYVbAvTu0gp5DKbBoUlPLug6yDcDilxQLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)